inherited FNFPorMunicipio: TFNFPorMunicipio
  Left = 165
  Top = 212
  Caption = 'Nota Fiscal por Munc'#237'pio'
  ClientHeight = 444
  ClientWidth = 930
  OldCreateOrder = True
  PixelsPerInch = 96
  TextHeight = 13
  inherited Panel2: TPanel
    Align = alNone
    inherited BtnImprimir: TBitBtn
      OnClick = BtnImprimirClick
    end
  end
  inherited Panel1: TPanel
    Height = 248
    Align = alNone
    object Label1: TLabel [0]
      Left = 8
      Top = 8
      Width = 14
      Height = 13
      Caption = 'UF'
    end
    object Label2: TLabel [1]
      Left = 64
      Top = 8
      Width = 47
      Height = 13
      Caption = 'Munic'#237'pio'
    end
    object Label3: TLabel [2]
      Left = 8
      Top = 48
      Width = 32
      Height = 13
      Caption = 'Cliente'
    end
    object Label10: TLabel [3]
      Left = 4
      Top = 151
      Width = 46
      Height = 13
      Caption = 'Empresas'
    end
    object Label4: TLabel [4]
      Left = 8
      Top = 88
      Width = 39
      Height = 13
      Caption = 'Emiss'#227'o'
    end
    object Label6: TLabel [5]
      Left = 112
      Top = 112
      Width = 6
      Height = 13
      Caption = 'a'
    end
    inherited DBGrid1: TDBGrid
      Left = 401
      Top = 109
      Align = alNone
      Visible = False
    end
    inherited Panel3: TPanel
      Top = 227
    end
    object dblUf: TDBLookupComboBox
      Left = 8
      Top = 24
      Width = 49
      Height = 21
      KeyField = 'MU_UF'
      ListField = 'MU_UF'
      ListSource = dsUf
      TabOrder = 2
      OnKeyDown = dblUfKeyDown
    end
    object dblMunicipio: TDBLookupComboBox
      Left = 64
      Top = 24
      Width = 337
      Height = 21
      KeyField = 'MU_CODIGO'
      ListField = 'MU_VCNOME'
      ListSource = dsMunicipio
      TabOrder = 3
      OnKeyDown = dblUfKeyDown
    end
    object dblCliente: TDBLookupComboBox
      Left = 8
      Top = 64
      Width = 393
      Height = 21
      KeyField = 'CLI_CODIGO'
      ListField = 'CLI_RAZAO'
      ListSource = dsCliente
      TabOrder = 4
      OnKeyDown = dblUfKeyDown
    end
    object CkBTodasEmpresas: TCheckBox
      Left = 4
      Top = 134
      Width = 118
      Height = 17
      Caption = 'Todas as Empresas'
      TabOrder = 5
      OnClick = CkBTodasEmpresasClick
    end
    object CLBEmpresas: TCheckListBox
      Left = 1
      Top = 170
      Width = 409
      Height = 57
      Align = alBottom
      Columns = 1
      ItemHeight = 13
      TabOrder = 6
    end
    object edDtEmissaoIni: TDateEdit
      Left = 8
      Top = 104
      Width = 100
      Height = 21
      NumGlyphs = 2
      TabOrder = 7
    end
    object edDtEmissaoFim: TDateEdit
      Left = 125
      Top = 104
      Width = 100
      Height = 21
      NumGlyphs = 2
      TabOrder = 8
    end
  end
  object RLReport1: TRLReport [2]
    Left = 104
    Top = 40
    Width = 794
    Height = 1123
    DataSource = DSPesquisa
    Font.Charset = DEFAULT_CHARSET
    Font.Color = clBlack
    Font.Height = -13
    Font.Name = 'Arial'
    Font.Style = []
    object RLBand1: TRLBand
      Left = 38
      Top = 38
      Width = 718
      Height = 72
      BandType = btHeader
      object rlEmpresa: TRLLabel
        Left = 2
        Top = 2
        Width = 51
        Height = 14
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object rlUf: TRLLabel
        Left = 2
        Top = 24
        Width = 20
        Height = 14
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object rlmunicipio: TRLLabel
        Left = 2
        Top = 40
        Width = 53
        Height = 14
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object rlCliente: TRLLabel
        Left = 2
        Top = 56
        Width = 41
        Height = 14
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
      object RLSystemInfo1: TRLSystemInfo
        Left = 614
        Top = 4
        Width = 99
        Height = 14
        Alignment = taRightJustify
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        Info = itPageNumber
        ParentFont = False
        Text = 'Pag.: '
      end
      object RLSystemInfo2: TRLSystemInfo
        Left = 634
        Top = 56
        Width = 79
        Height = 14
        Alignment = taRightJustify
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
        Text = 'Emiss'#227'o: '
      end
      object RLLabel13: TRLLabel
        Left = 228
        Top = 25
        Width = 262
        Height = 22
        Align = faCenter
        Caption = 'Notas Fiscais por Munic'#237'pio'
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -19
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
      end
      object rlPeriodoEmissao: TRLLabel
        Left = 314
        Top = 45
        Width = 86
        Height = 14
        Alignment = taCenter
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        ParentFont = False
      end
    end
    object rlgUf: TRLGroup
      Left = 38
      Top = 110
      Width = 718
      Height = 211
      DataFields = 'MU_UF'
      object rlColumUf: TRLBand
        Left = 0
        Top = 15
        Width = 718
        Height = 16
        BandType = btColumnHeader
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        PageBreaking = pbBeforePrint
        ParentFont = False
        object RLDBText1: TRLDBText
          Left = 2
          Top = 0
          Width = 82
          Height = 14
          DataField = 'MU_UF'
          DataSource = DSPesquisa
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          ParentFont = False
          Text = 'Estado: '
          BeforePrint = RLDBText1BeforePrint
        end
      end
      object rlgMunicipio: TRLGroup
        Left = 0
        Top = 31
        Width = 718
        Height = 130
        DataFields = 'MU_VCNOME'
        object rlColumMunicipio: TRLBand
          Left = 0
          Top = 0
          Width = 718
          Height = 16
          BandType = btColumnHeader
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
          object RLDBText2: TRLDBText
            Left = 32
            Top = 0
            Width = 132
            Height = 14
            DataField = 'MU_VCNOME'
            DataSource = DSPesquisa
            Font.Charset = DEFAULT_CHARSET
            Font.Color = clBlack
            Font.Height = -11
            Font.Name = 'Arial'
            Font.Style = [fsBold]
            ParentFont = False
            Text = 'Munic'#237'pio: '
            BeforePrint = RLDBText2BeforePrint
          end
        end
        object rlGClientes: TRLGroup
          Left = 0
          Top = 16
          Width = 718
          Height = 65
          DataFields = 'CLI_RAZAO'
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
          object rlColumClientes: TRLBand
            Left = 0
            Top = 0
            Width = 718
            Height = 16
            BandType = btColumnHeader
            Borders.Sides = sdCustom
            Borders.DrawLeft = False
            Borders.DrawTop = True
            Borders.DrawRight = False
            Borders.DrawBottom = False
            Font.Charset = DEFAULT_CHARSET
            Font.Color = clBlack
            Font.Height = -11
            Font.Name = 'Arial'
            Font.Style = []
            ParentFont = False
            object RLDBText3: TRLDBText
              Left = 64
              Top = 0
              Width = 110
              Height = 14
              DataField = 'CLI_RAZAO'
              DataSource = DSPesquisa
              Font.Charset = DEFAULT_CHARSET
              Font.Color = clBlack
              Font.Height = -11
              Font.Name = 'Arial'
              Font.Style = [fsBold]
              ParentFont = False
              Text = 'Cliente: '
              BeforePrint = RLDBText3BeforePrint
            end
          end
          object rlDetalhe: TRLBand
            Left = 0
            Top = 16
            Width = 718
            Height = 15
            Font.Charset = DEFAULT_CHARSET
            Font.Color = clBlack
            Font.Height = -11
            Font.Name = 'Arial'
            Font.Style = []
            ParentFont = False
            BeforePrint = rlDetalheBeforePrint
            object RLDBText4: TRLDBText
              Left = 152
              Top = 0
              Width = 81
              Height = 14
              AutoSize = False
              DataField = 'NF_NUMERONF'
              DataSource = DSPesquisa
              BeforePrint = RLDBText4BeforePrint
            end
            object RLDBText6: TRLDBText
              Left = 510
              Top = 0
              Width = 64
              Height = 14
              Alignment = taRightJustify
              DataField = 'NF_PERCISS'
              DataSource = DSPesquisa
              BeforePrint = RLDBText6BeforePrint
            end
            object RLDBText7: TRLDBText
              Left = 631
              Top = 0
              Width = 75
              Height = 14
              Alignment = taRightJustify
              DataField = 'NF_VALORISS'
              DataSource = DSPesquisa
              BeforePrint = RLDBText7BeforePrint
            end
            object RLDBText8: TRLDBText
              Left = 708
              Top = 0
              Width = 9
              Height = 14
              AutoSize = False
              DataField = 'NF_RETEMISS'
              DataSource = DSPesquisa
              BeforePrint = RLDBText8BeforePrint
            end
            object RLDBText9: TRLDBText
              Left = 248
              Top = 0
              Width = 97
              Height = 14
              Alignment = taRightJustify
              AutoSize = False
              DataField = 'NF_VALORFINALNOTA'
              DataSource = DSPesquisa
              BeforePrint = RLDBText9BeforePrint
            end
            object RLDBText10: TRLDBText
              Left = 376
              Top = 1
              Width = 73
              Height = 14
              Alignment = taRightJustify
              AutoSize = False
              DataField = 'NF_DATAEMISSAO'
              DataSource = DSPesquisa
            end
          end
          object RLBand3: TRLBand
            Left = 0
            Top = 31
            Width = 718
            Height = 34
            BandType = btSummary
            Borders.Sides = sdCustom
            Borders.DrawLeft = False
            Borders.DrawTop = False
            Borders.DrawRight = False
            Borders.DrawBottom = False
            BeforePrint = RLBand3BeforePrint
            object rlTrCliente: TRLLabel
              Left = 616
              Top = 2
              Width = 90
              Height = 14
              Alignment = taRightJustify
              AutoSize = False
              Borders.Sides = sdCustom
              Borders.DrawLeft = False
              Borders.DrawTop = True
              Borders.DrawRight = False
              Borders.DrawBottom = False
              Borders.Style = bsCross
            end
            object rlTnrCliente: TRLLabel
              Left = 616
              Top = 16
              Width = 90
              Height = 14
              Alignment = taRightJustify
              AutoSize = False
            end
            object RLLabel7: TRLLabel
              Left = 480
              Top = 2
              Width = 112
              Height = 14
              Alignment = taRightJustify
              Caption = 'Total Retido do Cliente:'
            end
            object RLLabel8: TRLLabel
              Left = 459
              Top = 16
              Width = 133
              Height = 14
              Alignment = taRightJustify
              Caption = 'Total n'#227'o Retido do Cliente:'
            end
            object RLDBResult1: TRLDBResult
              Left = 196
              Top = 16
              Width = 149
              Height = 14
              Alignment = taRightJustify
              DataField = 'NF_VALORFINALNOTA'
              DataSource = DSPesquisa
              DisplayMask = '#,##0.00'
              Info = riSum
              ResetAfterPrint = True
            end
          end
        end
        object RLBand4: TRLBand
          Left = 0
          Top = 81
          Width = 718
          Height = 40
          BandType = btSummary
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -11
          Font.Name = 'Arial'
          Font.Style = []
          ParentFont = False
          BeforePrint = RLBand4BeforePrint
          object rlTrMunicipio: TRLLabel
            Left = 643
            Top = 8
            Width = 63
            Height = 14
            Alignment = taRightJustify
          end
          object rlTnrMunicipio: TRLLabel
            Left = 637
            Top = 22
            Width = 69
            Height = 14
            Alignment = taRightJustify
          end
          object RLLabel9: TRLLabel
            Left = 468
            Top = 8
            Width = 124
            Height = 14
            Alignment = taRightJustify
            Caption = 'Total Retido do Munic'#237'pio:'
          end
          object RLLabel10: TRLLabel
            Left = 447
            Top = 22
            Width = 145
            Height = 14
            Alignment = taRightJustify
            Caption = 'Total n'#227'o Retido do Munic'#237'pio:'
          end
          object RLDBResult2: TRLDBResult
            Left = 196
            Top = 24
            Width = 149
            Height = 14
            Alignment = taRightJustify
            DataField = 'NF_VALORFINALNOTA'
            DataSource = DSPesquisa
            DisplayMask = '#,##0.00'
            Info = riSum
            ResetAfterPrint = True
          end
        end
      end
      object RLBand2: TRLBand
        Left = 0
        Top = 0
        Width = 718
        Height = 15
        BandType = btHeader
        Borders.Sides = sdCustom
        Borders.DrawLeft = False
        Borders.DrawTop = True
        Borders.DrawRight = False
        Borders.DrawBottom = True
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
        object RLLabel1: TRLLabel
          Left = 152
          Top = 0
          Width = 16
          Height = 14
          Caption = 'NF'
        end
        object RLLabel3: TRLLabel
          Left = 526
          Top = 0
          Width = 48
          Height = 14
          Caption = 'Al'#237'quota'
        end
        object RLLabel4: TRLLabel
          Left = 639
          Top = 0
          Width = 69
          Height = 14
          Alignment = taRightJustify
          Caption = 'Valor do ISS'
        end
        object RLLabel5: TRLLabel
          Left = 297
          Top = 1
          Width = 48
          Height = 14
          Caption = 'NF Valor'
        end
        object RLLabel6: TRLLabel
          Left = 398
          Top = 1
          Width = 50
          Height = 14
          Caption = 'Emiss'#227'o'
        end
      end
      object RLBand5: TRLBand
        Left = 0
        Top = 161
        Width = 718
        Height = 45
        BandType = btSummary
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clBlack
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = [fsBold]
        ParentFont = False
        BeforePrint = RLBand5BeforePrint
        object rlTrUf: TRLLabel
          Left = 672
          Top = 8
          Width = 34
          Height = 14
          Alignment = taRightJustify
        end
        object rlTnrUf: TRLLabel
          Left = 665
          Top = 22
          Width = 41
          Height = 14
          Alignment = taRightJustify
        end
        object RLLabel11: TRLLabel
          Left = 464
          Top = 8
          Width = 128
          Height = 14
          Alignment = taRightJustify
          Caption = 'Total Retido do Estado:'
        end
        object RLLabel12: TRLLabel
          Left = 441
          Top = 22
          Width = 151
          Height = 14
          Alignment = taRightJustify
          Caption = 'Total n'#227'o Retido do Estado:'
        end
        object RLDBResult3: TRLDBResult
          Left = 188
          Top = 22
          Width = 157
          Height = 14
          Alignment = taRightJustify
          DataField = 'NF_VALORFINALNOTA'
          DataSource = DSPesquisa
          DisplayMask = '#,##0.00'
          Info = riSum
          ResetAfterPrint = True
        end
      end
    end
    object RLBand6: TRLBand
      Left = 38
      Top = 321
      Width = 718
      Height = 40
      BandType = btSummary
      Borders.Sides = sdCustom
      Borders.DrawLeft = False
      Borders.DrawTop = True
      Borders.DrawRight = False
      Borders.DrawBottom = False
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clBlack
      Font.Height = -13
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      BeforePrint = RLBand6BeforePrint
      object RLDBResult4: TRLDBResult
        Left = 157
        Top = 2
        Width = 188
        Height = 16
        Alignment = taRightJustify
        DataField = 'NF_VALORFINALNOTA'
        DataSource = DSPesquisa
        DisplayMask = '#,##0.00'
        Info = riSum
      end
      object rlRTotalGeral: TRLLabel
        Left = 617
        Top = 2
        Width = 89
        Height = 16
        Alignment = taRightJustify
      end
      object rlNrTotalGeral: TRLLabel
        Left = 612
        Top = 20
        Width = 94
        Height = 16
        Alignment = taRightJustify
      end
      object RLLabel14: TRLLabel
        Left = 8
        Top = 2
        Width = 75
        Height = 16
        Caption = 'Total Geral'
      end
      object RLLabel15: TRLLabel
        Left = 441
        Top = 2
        Width = 151
        Height = 16
        Alignment = taRightJustify
        Caption = 'Total Retido do Estado:'
      end
      object RLLabel16: TRLLabel
        Left = 441
        Top = 20
        Width = 151
        Height = 16
        Alignment = taRightJustify
        Caption = 'Total Retido do Estado:'
      end
    end
  end
  inherited QPesquisa: TQuery
    Active = True
    SQL.Strings = (
      'SELECT'
      '  MUNICIPIO.MU_UF,'
      '  MUNICIPIO.MU_VCNOME,'
      '  NOTAFISCALVENDA.NF_NUMERONF,'
      '  NOTAFISCALVENDA.NF_DATAVENCIMENTO,'
      '  NOTAFISCALVENDA.NF_DATAEMISSAO,'
      '  NOTAFISCALVENDA.NF_PERCISS,'
      '  NOTAFISCALVENDA.NF_VALORISS,'
      '  NOTAFISCALVENDA.NF_VALORFINALNOTA,'
      '  NOTAFISCALVENDA.NF_RETEMISS,'
      '  CLIENTE.CLI_RAZAO'
      'FROM'
      '  NOTAFISCALVENDA'
      
        '  LEFT  JOIN MUNICIPIO ON (NOTAFISCALVENDA.NF_MUNICIPIO=MUNICIPI' +
        'O.MU_CODIGO)'
      
        '  INNER JOIN CLIENTE   ON (NOTAFISCALVENDA.NF_CLIENTE = CLIENTE.' +
        'CLI_CODIGO)'
      'WHERE'
      '  (NOTAFISCALVENDA.NF_SITUACAO > 0)AND'
      '  (NOTAFISCALVENDA.CODIGOEMPRESA IN (1))'
      'ORDER BY'
      '  MUNICIPIO.MU_UF,'
      '  MUNICIPIO.MU_VCNOME,'
      '  CLIENTE.CLI_RAZAO,'
      '  NOTAFISCALVENDA.NF_NUMERONF,'
      '  NOTAFISCALVENDA.NF_DATAVENCIMENTO')
  end
  inherited DSPesquisa: TDataSource
    Left = 248
    Top = 89
  end
  object dsCliente: TDataSource
    DataSet = DMGestao.QCliente
    Left = 96
    Top = 56
  end
  object dsMunicipio: TDataSource
    DataSet = DMGestao.QMunicipio
    Left = 160
    Top = 56
  end
  object dsUf: TDataSource
    DataSet = DMGestao.QUF
    Left = 224
    Top = 56
  end
end
